|
| Technical information |
| Error type | 256 |
| Error description | You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ) ) a' at line 3 |
| URL | asprunner.com/forums/forumtopics_list.php?category_alias=avatars/20170519_115657041_iOS%20-%20Copy%20(2 |
| Error file | C:\inetpub\wwwroot\asprunner.com\public_html\forums\connections\Connection.php |
| Error line | 668 |
| SQL query | select count(*) from (SELECT
`topic`, `topic` as `topic2`, `startedby`, `startedby` as `startedby2`, `id`, `categoryid`, `views`, `activity`, `pinned`, "" as `color`, `question`, `created`, `solved`, "" as `image`, `migrate_alias`, `locked`, "" as `ai`, `files`, (select COUNT(*) FROM forumreplies AS r WHERE r.topicid = forumtopics.id) as `forumreplies`
FROM `forumtopics` WHERE ( ( ( ( forumtopics.id is null ) or ( forumtopics.id > 0 ) or ( forumtopics.id=0 ) or ( forumtopics.id < 0 ) ) ) ) and ( (categoryid=) ) ) a |
| #0 |
connections\Connection.php:668 |
Connection->triggerError |
0. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ) ) a' at line 3 |
| #1 |
connections\MySQLiConnection.php:168 |
MySQLiConnection->query |
0. select count(*) from (SELECT
`topic`, `topic` as `topic2`, `startedby`, `startedby` as `startedby2`, `id`, `categoryid`, `views`, `activity`, `pinned`, "" as `color`, `question`, `created`, `solved`, "" as `image`, `migrate_alias`, `locked`, "" as `ai`, `files`, (select COUNT(*) FROM forumreplies AS r WHERE r.topicid = forumtopics.id) as `forumreplies`
FROM `forumtopics` WHERE ( ( ( ( forumtopics.id is null ) or ( forumtopics.id > 0 ) or ( forumtopics.id=0 ) or ( forumtopics.id < 0 ) ) ) ) and ( (categoryid=) ) ) a |
| #2 |
connections\Connection.php:635 |
Connection->getFetchedRowsNumber |
0. SELECT
`topic`, `topic` as `topic2`, `startedby`, `startedby` as `startedby2`, `id`, `categoryid`, `views`, `activity`, `pinned`, "" as `color`, `question`, `created`, `solved`, "" as `image`, `migrate_alias`, `locked`, "" as `ai`, `files`, (select COUNT(*) FROM forumreplies AS r WHERE r.topicid = forumtopics.id) as `forumreplies`
FROM `forumtopics` WHERE ( ( ( ( forumtopics.id is null ) or ( forumtopics.id > 0 ) or ( forumtopics.id=0 ) or ( forumtopics.id < 0 ) ) ) ) and ( (categoryid=) ) |
| #3 |
classes\datasource\table.php:624 |
DataSourceTable->getCount |
0. DsCommand |
| #4 |
classes\listpage.php:2800 |
ListPage->calculateRecordCount |
N/A |
| #5 |
classes\listpage.php:2205 |
ListPage->prepareForBuildPage |
N/A |
| #6 |
forumtopics_list.php:158 |
Global scope |
N/A |